package com.topisv.tms.repository.stock.preInstorage;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.stock.instorage.pre.InstorageBillBoxPre;

/**
 * 预约入库DAO
 *  Date          Author       Version       Description
 * ----------------------------------------------------------
 *  2014-7-3      CC            1.0           Create
 */
public interface InstorageBillBoxPreDao extends PagingAndSortingRepository<InstorageBillBoxPre, Long>, JpaSpecificationExecutor<InstorageBillBoxPre> {
	@Modifying
	@Query("delete InstorageBillBoxPre t where t.billPreId=?")
	void deleteInstorageBillBoxPre(Long id);
	
	@Query("select t from InstorageBillBoxPre t where t.billPreId=?")
	List<InstorageBillBoxPre> query(Long id);
}
